StudentCourse

EntityType | Independent
Logical Entity Name | StudentCourse
Default Table Name | AdEnrollSched
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentCourse Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentId |  | INTEGER | YES |
ClassSectionId |  | INTEGER | YES |
TermId |  | INTEGER | YES |
AcademicYear |  | TINYINT | NO |
CourseName |  | VARCHAR(75) | NO |
StartDate |  | DATETIME | YES |
ExpectedEndDate |  | DATETIME | YES |
EndDate |  | DATETIME | YES |
LDA |  | DATETIME | YES |
GradePostedDate |  | DATETIME | YES |
DropDate |  | DATETIME | YES |
BilledDate |  | DATETIME | YES |
IsExtended |  | BIT | NO |
IsExtensionBilled |  | DATETIME | YES |
Status |  | CHAR(1) | NO |
PreviousStatus |  | CHAR(1) | YES |
Note |  | VARCHAR(4000) | YES |
TranscriptNote |  | VARCHAR(3000) | YES |
Cost |  | MONEY(19, 4) | NO |
MinutesAttended |  | INTEGER | NO |
MinutesAbsent |  | INTEGER | NO |
IsCostScheduled |  | BIT | NO |
CreditHours |  | NUMERIC(9, 2) | NO |
ClockHours |  | NUMERIC(9, 2) | YES |
NumericGrade |  | NUMERIC(11, 6) | YES |
LetterGrade |  | CHAR(8) | NO |
RetakeFlag |  | CHAR(1) | YES |
Speed |  | TINYINT | YES |
GradePoints |  | NUMERIC(9, 2) | NO |
QualityPoints |  | NUMERIC(9, 2) | YES |
CreditHoursAttempted |  | NUMERIC(9, 2) | NO |
CreditHoursEarned |  | NUMERIC(9, 2) | NO |
ClockHoursAttempted |  | NUMERIC(9, 2) | NO |
ClockHoursEarned |  | NUMERIC(9, 2) | NO |
IsIncludedInGpaCalc |  | BIT | NO |
PayStatus |  | CHAR(1) | YES |
ModFlag |  | CHAR(1) | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
StudentCourseId |  | INTEGER | NO |
CourseId |  | INTEGER | YES |
RequiredCourseId |  | INTEGER | YES |
CollegeId |  | INTEGER | YES |
IsSubstitute |  | BIT | YES |
SubstituteCourseId |  | INTEGER | YES |
IsTransferCredit |  | BIT | YES |
DependentClassSectionId |  | INTEGER | YES |
IsAutoDrop |  | BIT | NO |
ConsecutiveMinutesAbsent |  | NUMERIC(18, 0) | NO |
RosterFlag |  | CHAR(2) | YES |
RevenueReferenceNumber |  | CHAR(8) | YES |
RetakeOverride |  | BIT | NO |
GradeScaleId |  | INTEGER | YES |
Include |  | BIT | NO |
MakeUpMinutes |  | INTEGER | NO |
DateReqMet |  | DATETIME | YES |
TransferredCourseCode |  | CHAR(16) | YES |
TransferredCourseDescrip |  | VARCHAR(75) | YES |
AdvisedDate |  | DATETIME | YES |
IsAfterAddDrop |  | BIT | NO |
StudentTransferCreditId |  | INTEGER | YES |
IsCrossReferencedCourse |  | BIT | YES |
CrossReferenceCourseId |  | INTEGER | YES |
MidTermNumericGrade |  | NUMERIC(11, 6) | YES |
MidTermLetterGrade |  | CHAR(8) | YES |
MidTermGradeNote |  | VARCHAR(350) | YES |
MidTermGradePostedDate |  | DATETIME | YES |
IsAuditCourse |  | BIT | YES |
AuditEffectiveDate |  | DATETIME | YES |
IsPassFail |  | BIT | NO |
LmsExtractStatus |  | CHAR(1) | YES |
InProgressGrade |  | NUMERIC(9, 2) | YES |
CourseFeeScheduleId |  | INTEGER | YES |
EnrollmentStatusCreditHours |  | MONEY(19, 4) | NO |
EnrollmentStatusClockHours |  | MONEY(19, 4) | NO |
FaStudentAyPaymentPeriodId |  | INTEGER | YES |
RetakeFeeWaived |  | CHAR(1) | NO |
IsCourseRefundPolicyUsed |  | BIT | NO |
ExpectedDeadlineDate |  | DATETIME | YES |
IsIncompleteGradeReplaced |  | BIT | NO |
HighSchoolId |  | INTEGER | YES |
TransferTypeId |  | INTEGER | YES |
RetakeTiv2CredEarnZeroed |  | BIT | NO |
RetakeTiv2CredEarnValue |  | MONEY(19, 4) | YES |
IsOnlyRateScheduleUsed |  | BIT | YES |
OverrideCourseProgression |  | CHAR(1) | YES |
OutsideCourseWorkHours |  | NUMERIC(9, 2) | NO |
StudentEnrollmentPeriodId |  | INTEGER | YES |

StudentCourse Keys

Key Name | Key Type | Keys
AdEnrollSched_Status_adDependentClassSchedID_AdEnrollSchedID_U_N_IDX | Alternate Key | Status, DependentClassSectionId, StudentCourseId
AdEnrollSched_AdEnrollID_Status_EndDate_AdCourseID_GPACalc_RetakeOverride_N_N_IDX | Inversion Entry | StudentCourseId, Status, EndDate, IsIncludedInGpaCalc, RetakeOverride
Nk_AdEnrollSchedAmTransferTypeID | Inversion Entry | TransferTypeId
AdEnrollSched_AdClassSchedId_Status_AfterAddDrop_N_N_idx | Inversion Entry | Id_2, Status, IsAfterAddDrop
AdEnrollSched_AdEnrollID_AdTermID_Status_Credits_CreditsAttempt_Hours_INCLUDE_N_N_IDX | Inversion Entry | StudentCourseId, Status, CreditHours, CreditHoursAttempted, ClockHours
AdEnrollSched_SyStudentID_StartDate_N_N_IDX | Inversion Entry | StartDate
AdEnrollSched_AdEnrollID_Status_GPACAlc_TransferCredit_RetakeOverRide_N_N_idx | Inversion Entry | StudentCourseId, Status, IsIncludedInGpaCalc, IsTransferCredit, RetakeOverride
NK_AdEnrollSched_AdEnrollID_Status_AdProgramCourseID_INCL | Inversion Entry | StudentCourseId, Status
NK_AdEnrollSchedAdEnrollIDAdCourseID | Inversion Entry | StudentCourseId
AdEnrollSched_Status_AdTermID_AdEnrollID_N_N_IDX | Inversion Entry | Status, StudentCourseId
AdEnrollSched_AdEnrollID_AdClassSchedID_AdCourseID_N_N_IDX | Inversion Entry | StudentCourseId, Id_2
AdEnrollSched_AmCollegeTransferID_N_N_IDX | Inversion Entry | StudentTransferCreditId
AdEnrollSched_AdEnrollID_AdTermID_StartDate_DropDate_EndDate_ExpectedEndDate_Status_AdClassSchedID_AdEnrollSchedID_U_N_IDX | Alternate Key | StudentCourseId, StartDate, DropDate, EndDate, ExpectedEndDate, Status, Id_2
AdEnrollSched_AdGradeLetterCode_N_N_IDX | Inversion Entry | LetterGrade
AdEnrollSched_AdCourseID_N_N_IDX | Inversion Entry | StudentCourseId
AdEnrollSched_RevenueRefNo_AdEnrollId_N_N_idx | Inversion Entry | RevenueReferenceNumber, StudentCourseId
AdEnrollSched_AdEnrollSchedID_U_C_IDX | PrimaryKey | StudentCourseId
AdEnrollSched_StartDate_SyStudentID_N_N_idx | Inversion Entry | StartDate
AdEnrollSched_SyStudentID_AdClassSchedId_AdEnrollSchedId_U_N_IDX | Inversion Entry | Id_2, StudentCourseId
adenrollsched_FaStudentAyPaymentPeriodId_N_N_IDX | Inversion Entry | FaStudentAyPaymentPeriodId
Nk_AdEnrollSchedAmHighSchoolID | Inversion Entry | HighSchoolId
AdEnrollSched_ModFlag_N_N_IDX | Inversion Entry | ModFlag
AdEnrollSched_SyStudentID_Status_AdCourseID_N_N_IDX | Inversion Entry | Status, StudentCourseId
AdEnrollSched_AdClassSchedId_AdTermID_IDX | Inversion Entry | Id_2
AdEnrollSched_AdTermID_AdEnrollSchedId_AdEnrollID_Status_SyStudentId_AdCourseId_U_N_IDX | Alternate Key | StudentCourseId, Status

StudentCourse Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
RequiredCourse | Non-Identifying | Zero or One to Zero or More |  |  |  | RequiredCourseId | NO
ClassSection | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionId | NO
Course | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseId | NO
StudentTransferCredit | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentTransferCreditId | NO
CourseFeeSchedule | Non-Identifying | Zero or One to Zero or More |  |  |  | CourseFeeScheduleId | NO
StudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  | StudentCourseId | NO
StudentCoursePendingRegistration | Non-Identifying | Zero or One to Zero or More |  |  |  | Id_2 | NO
StudentAcademicYearPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | FaStudentAyPaymentPeriodId | NO
HighSchool | Non-Identifying | Zero or One to Zero or More |  |  |  | HighSchoolId | NO
TransferCreditType | Non-Identifying | Zero or One to Zero or More |  |  |  | TransferTypeId | NO
GradeScale | Non-Identifying | Zero or One to Zero or More |  |  |  | GradeScaleId | NO
RequiredCourse | Non-Identifying | Zero or One to Zero or More |  |  |  | RequiredCourseId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
StudentCourseStudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentDpaTakenNotAppliedCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentDpaFulfillment | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
Attendance | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdAttendArchive | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentDpaTakenNotAppliedCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentDpaFulfillment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodLesson | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdEnrollLessonRetake | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseExtension | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseStudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdEnrollSchedProspectTestMapping | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdEnrollSchedStatusHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentGpaIncludedCourse | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
StudentCourseSpeCourseCategory | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodTransferCourse | Identifying | One To Zero or More |  |  |  |  | NO
ScheduledDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutomaticBillingBatchDetailCourse | Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
Attendance | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseExtension | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseStatusChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseStudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentDegreePathway | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentDpaFulfillment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentDpaTakenNotAppliedCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentGpaIncludedCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentPlacement | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentCourse Check Constraints

Check Constraint Name | CheckConstraint
Chk_AdEnrollSched_MinutesMakeUp | ([Hours] = 0 or [MinutesMakeUp] <= [Hours] * 60)
Chk_AdEnrollSched_TransferredCourseCode | ([TransferredCourseCode] is null or [TransferCredit] = 1)
Chk_AdEnrollSched_TransferredCourseDescrip | ([TransferredCourseDescrip] is null or [TransferCredit] = 1)

StudentCourse Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentCourse | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdEnrollSched | NO |  |  |

StudentCourse Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | CourseRegistration
Logical | DegreePathway
Logical | Grades/Attendance
Logical | StudentJobPlacement
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

StudentCourse Data Movement Rules

Name | Type | Rule Text/Value